Query Builder Sorting

Open Query Builder.

Click the Sorting tab.

Select a table from the left side of the Query Builder. If necessary, click the plus sign to expand the list of tables.

Select a field from the right side of the Query Builder. This box displays all fields that belong to the selected table. Double-click the field to add it to the grid at the bottom of the dialog box.

Click the Direction drop-down arrow, and then select Ascending (sorts from A to Z) or Descending (sorts from Z to A).

To add a secondary sorting field, repeat steps 3-5. Every subsequent sort will be applied as a sublevel of the sort preceding it.

Open Query Builder.

Click the Sorting tab.

Select a field in the grid.

Click Move Up or Move Down.

Open Query Builder.

Click the Sorting tab.

Select the field to delete from the grid.

Click Delete.